An index in a database lets you quickly find specific information in a table or indexed view. An index contains keys built from one or more columns in the table, or view, and pointers that map to the storage location of the specified data. You can significantly improve the performance of database queries and applications by creating well-designed indexes to support your queries. Indexes can reduce the amount of data that must be read to return the query result set. Indexes can also enforce uniqueness on the rows in a table, ensuring the data integrity of the table data.
Just simply click ->
Index to open
an object pane for Index. A control-click displays the popup
menu or using the object pane toolbar below, allowing you to create new, edit
and delete the selected Index.
Create Index
To create a new index
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Index from the popup menu.
- Edit index properties on the appropriate tabs of the Index Designer.
To create a new index with modification as one of the existing index
- Select the index for modifying in the object pane.
- Control-click and select the Design
Index from the popup menu or simply double-click the index.
or - Click the
from the object pane toolbar.
- Modify index properties on the appropriate tabs of the Index Designer.
- Click
Save As.
To edit the existing index (manage its properties etc)
- Select the index for editing in the object pane.
- Control-click and select the Design
Index from the popup menu or simply double-click the index.
or - Click the
from the object pane toolbar.
- Edit index properties on the appropriate tabs of the Index Designer.
To change the name of the index
- Select the index for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Maintain Index
To maintain an index
- Select the index for maintaining in the object pane.
- Control-click and select the Maintain from the popup menu.
- Rebuild Index
- Disable Index
Delete Index
To delete an index
- Select the index for deleting in the object pane.
- Control-click and select the Delete Index
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Index Information
To achieve an index information
- Select the index in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.